创建数据存储文件夹

mkdir /data/clickhouse/data
mkdir /data/clickhouse/logs

启动容器

docker run --privileged -d --name clickhouse-server -p 18123:8123 -p 19000:9000 -v /data/clickhouse/data:/var/lib/clickhouse -v /data/clickhouse/logs:/var/log/clickhouse-server -e CLICKHOUSE_DB=my_database -e CLICKHOUSE_USER=llqqyy -e CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1 -e CLICKHOUSE_PASSWORD=ppsswwdd --ulimit nofile=262144:262144 clickhouse/clickhouse-server

创建表

CREATE TABLE nginx_logs ( remote_addr String, remote_user String, time_local DateTime, request String, status Int32, body_bytes_sent Int64, http_referer String, http_user_agent String, request_time Float32, upstream_response_time Float32, pipe String ) ENGINE = MergeTree() ORDER BY time_local;